<cfquery name="getemail" datasource="exp" >
select * from user where id=#session.id#
</cfquery>

<cfmail type="html" 
from="#getemail.email#" 
subject="Experiment Link" 
to="#getemail.email#"
server="mr1.dcs.gla.ac.uk"
spoolenable="no">
Please click the link to participate in the experiment:

http://bantayan.dcs.gla.ac.uk/ecada/ethics.cfm?id=#id#

thanks!
</cfmail> 

<cfset session.message = "Experiment #id# Link has been emailed to you">
<cflocation url="/ecada/viewexp/expView.cfm?id=#id#">
